using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace LHS.Core.TableInfo
{
    public class InfoEmployees
    {
        public const string EMPISN = "empISN";
        public const string EMPID = "empID";
        public const string EMPNAME = "empName";
        public const string EMPBIRTHDATE = "empBirthDate";
        public const string EMPAGE = "empAge";
        public const string EMPSEX = "empSex";
        public const string EMPPOSITION = "empPosition";
        public const string EMPSPECIALIZE = "empSpecialize";
        public const string EMPADDRESS = "empAddress";
        public const string EMPTEL = "empTel";
        public const string EMPMOBILE = "empMobile";
        public const string EMPEMAIL = "empEmail";
        public const string EMPSIGNATUREIMAGE = "empSignatureImage"; //moi them 20090603
        public const string TABLENAME = "Employees";

        public static DataTable GetStructure()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(EMPISN, typeof(int));
            dt.Columns.Add(EMPID, typeof(string));
            dt.Columns.Add(EMPNAME, typeof(string));
            dt.Columns.Add(EMPBIRTHDATE, typeof(DateTime));
            dt.Columns.Add(EMPAGE, typeof(int));
            dt.Columns.Add(EMPSEX, typeof(string));
            dt.Columns.Add(EMPPOSITION, typeof(string));
            dt.Columns.Add(EMPSPECIALIZE, typeof(string));
            dt.Columns.Add(EMPADDRESS, typeof(string));
            dt.Columns.Add(EMPTEL, typeof(string));
            dt.Columns.Add(EMPMOBILE, typeof(string));
            dt.Columns.Add(EMPEMAIL, typeof(string));
            dt.Columns.Add(EMPSIGNATUREIMAGE, typeof(byte[])); //kiem tra lai
            dt.TableName = TABLENAME;
            return dt;
        }

    }
}
